select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Purple Strapless Pic-ups and Appliques Ball Gown Dresses of 15
Unique Hunter Multi-tiered Strapless Ball Gown Dresses for a Quince
Elegant Apple Blue Ball Gown Pick-ups Appliques Sweet 15 Dresses
Rose Pink Beading Sweet Heart Sweet Sixteen Dresses with Ruffles
Rose Pink and Black Quinceanera Gown Dress with Ruffled Layers
Rose Pink and White Appliqued Ruffled Quinceanera Dresses
Colorful Off The Shoulder Dress for a Quince with Appliques
Charming Ball Gown Strapless Hot Pink Dresses for a Quinceanera
Popular Lilac and White One Shoulder Appliqued Sweet 15 Dress
Discount Hot Pink Corset Appliqued Quinceanera Gowns Online
Cute Strapless White Sweet Sixteen Dress with Fuchsia Appliques
Elegant Ball Gown Strapless Leopard Print Quinceanera Dresses
Court Train Pick-ups Purple and Watermelon Sweet 15 Dresses
Popular Pick Ups Printing Multi-color Sweet 15 Dress Online
Multi-tiered Beaded Blue and Yellow Quinceanera Gown Dresses
Multi-color Off The Shoulder Appliqued Sweet Sixteen Dresses
Expensive Handmade Flowers Appliqued Red Dress for Sweet 15
Appliqued Pick Ups Fuchsia Ball Gown Dresses for Sweet 16
Rolling Flowers Wine Red Sweet Sixteen Quinceanera Dresses
Slot Neck Leopard Print Pick Ups Multi-color Quinceanera Gown
Ball Gown Strapless Ruffled Two-toned Sweet Sixteen Dresses
Green Ball Gown Organza Quinceanera Gown Dresses with Pick-ups
Spaghetti Straps Beaded Ball Gown Tulle Sweet Sixteen Dresses
Purple Ball Gown Taffeta Sweet Sixteen Dresses with Pick-ups
Ball Gown Floor-length Taffeta Appliques Quinceanera Dresses
Sweetheart Ball Gown Taffeta Sweet Sixteen Dresses with Train
One Shoulder Ball Gown Flower Length Tulle Quinceanera Dresses
New Arrival White Ball Gown Organza Sweet Sixteen Dresses
Green Ball Gown Taffeta Sweet Sixteen Dresses with Pick-ups
Green Ball Gown Organza Sweet Sixteen Dresses with Flowers